﻿/*   
    Copyright (C) 2009 Galaktika Corporation ZAO

    This file is a part of Galaktika.BusinessMonitor
 
    Galaktika.BusinessMonitor is a free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.
      
    You should have received a copy of the GNU General Public License
    along with Galaktika.BusinessMonitor.  If not, see <http://www.gnu.org/licenses/>.
  
    If GPL v.3 is not suitable for your products or company,
    Galaktika Corp provides Galaktika.BusinessMonitor under a flexible commercial license
    designed to meet your specific usage and distribution requirements.
    If you have already obtained a commercial license from Galaktika Corp,
    you can use this file under those license terms.
*/

using System;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Ink;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using Galaktika.BI.Silverlight.Runtime.Data;
using Galaktika.BI.Runtime.Services;
using Galaktika.BI.Silverlight.Services;
using Galaktika.BI.Silverlight.Commands;
using Ranet.ZipLib;

namespace Galaktika.BI.Silverlight.ClientApp.Web.Runtime.DataAccess
{
    public class DbQueryExecutor
    {
        internal static DataTableWrapper ExecuteQuery(
            string connectionString, 
            string query, 
            ConnectionType type, 
            string dataSourceId,
            IBindingContext context)
        {
            string contextId = context != null ? ((IUniquedObject)context).Id : null;
            using (var srv = new SyncDataService())
            {
                InvokeSchema cmd;
                switch (type)
                {
                    case ConnectionType.Odbc:
                        cmd = CommandBuilder.CreateGetOdbcCommand(connectionString, query, contextId, dataSourceId);
                        break;
                    case ConnectionType.OleDb:
                        cmd = CommandBuilder.CreateGetOleDbCommand(connectionString, query, contextId, dataSourceId);
                        break;
                    case ConnectionType.SqlServer:
                        cmd = CommandBuilder.CreateGetSqlCommand(connectionString, query, contextId, dataSourceId);
                        break;
                    default:
                        throw new Exception(string.Format("Unsupported db connection type '{0}'", type));
                }
                var res = srv.InvokeCommand(cmd);

                if (res.ContentType == KnownContentTypes.RelationalData)
                {
                    if (res.IsArchive)
                    {
                        var content = ZipCompressor.DecompressFromBase64String(res.Content);
                        return XmlUtility.XmlStr2Obj<DataTableWrapper>(content);
                    }
                    return XmlUtility.XmlStr2Obj<DataTableWrapper>(res.Content);
                }

            }

            return null;
        }
    }
}
